package com.eascs.credit.dao;

import org.springframework.stereotype.Repository;

import com.eascs.admin.common.dao.BaseOaDao;
import com.eascs.credit.entity.CreditResolve;

/**
 * 附件DAO--老系统OA
 * @author ycz
 *
 */
@Repository
public class OaDatalistDao extends BaseOaDao{
	/**
	 * 老系统查询征信附件地址
	 * @param loanId
	 * @return
	 */
	 public CreditResolve findUrl(String loanId){
		 String sql="select t.attachmentname as url from eadb.pub_attachment t  where t.relatedno=? and t.ATTACHMENTTYPE='ZXBGDATA'";
		 return super.findEntity(sql, CreditResolve.class, loanId);
	 }
}
